Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
AddressID (PK) | A unique system allocated identifier for the Address. | ID_ADS | Identity | integer | |
AddressLine1 | The first line of the address, normally the street number and name. | A1_ADS | Address | varchar(80) | |
AddressLine2 | The second line of an address, normally the Flat or Building Suite number. | A2_ADS | Address | varchar(80) | |
AddressLine3 | The third line of the address. | A3_ADS | Address | varchar(80) | |
AddressLine4 | The fourth line of the address. | A4_ADS | Address | varchar(80) | |
City | The city, town or village component of the address | CI_CNCT | City | varchar(30) | |
Territory | The County, State, Province, Territory etc component of the address | ST_CNCT | State | char(2) | |
GeographicSegmentID (FK) | Token ID for a GeographicSegment which is used to categorize customers based on where they live, shop and work. | ID_GEO_SGMT | Identity | integer | GeographicSegment(CO_GEO_SGMT) |
ISO_3166-2CountrySubDivisionID (FK) | Token ID assigned to uniquely identify all country-primary subdivision instances. This token is non-signifcant and should be automatically generated. | ID_ISO_3166_2_CY_SBDVN | Identity | integer | ISO3166-2CountrySubdivision(CO_ISO3166_2_PRMRY_SBDVN) |
PostalCodeID (FK) | A token identifier for a generic postal code. Postal codes vary in format, structure and content from one country to another. This generic ID ensures that each postal code is unique across ALL COUNTRIES. | ID_PSTL_CD | Identity | integer | PostalCodeReference(LU_PSTL_CD_RFC) |